package com.changsideal;

import com.changsideal.excel.annotation.Column;
import com.changsideal.excel.annotation.Sheet;
import com.changsideal.excel.annotation.Table;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.util.Date;

/**
 * @ClassName MyExcel
 * @Description TODO
 * @Author Create by Chansideal.Haosc
 * @Date 2019/7/5 15:31
 * @Version 1.0
 **/
@Getter
@Setter
@Sheet(value = "sheet1")
@Table(value = "userInfo", dbType = "oracle")
@ToString
public class MyExcel {
    @Column(value = "序号", width = 30)
    private Integer columnNo;
    @Column(value = "用户名称", width = 120, alignStyle = HorizontalAlignment.LEFT, sqlFlag = true, sqlOrder = 1)
    private String userName;
    @Column(value = "用户小名", width = 120, sqlFlag = true)
    private String userAlia;
    @Column(value = "用户年龄", width = 80)
    private Integer userAge;
    @Column(value = "用户性别", width = 80, sqlOrder = 1)
    private String userType;
    @Column(value = "生日", sqlFlag = true, dateFormat = "yyyy-MM-dd", sqlOrder = 1)
    private Date bornDate;
}
